Overview
Brought to you by YData
Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 1401 |
| Missing cells | 12914 |
| Missing cells (%) | 29.7% |
| Duplicate rows | 2 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 339.4 KiB |
| Average record size in memory | 248.1 B |
Variable types
| Text | 7 |
|---|---|
| DateTime | 2 |
| Categorical | 11 |
| Numeric | 8 |
| Unsupported | 3 |
Currency has constant value "USD" | Constant |
Fulfillment Status has constant value "Completed" | Constant |
Fulfillment Location has constant value "Belly Rubb" | Constant |
Recipient Region has constant value "CA" | Constant |
| Dataset has 2 (0.1%) duplicate rows | Duplicates |
Channels is highly overall correlated with Fulfillment Type and 8 other fields | High correlation |
Fulfillment Type is highly overall correlated with Channels and 5 other fields | High correlation |
Item Options Total Price is highly overall correlated with Channels and 3 other fields | High correlation |
Item Price is highly overall correlated with Channels and 3 other fields | High correlation |
Item Quantity is highly overall correlated with Recipient Address and 2 other fields | High correlation |
Item Total Price is highly overall correlated with Channels and 3 other fields | High correlation |
Order Subtotal is highly overall correlated with Order Tax Total and 4 other fields | High correlation |
Order Tax Total is highly overall correlated with Order Subtotal and 4 other fields | High correlation |
Order Total is highly overall correlated with Order Subtotal and 4 other fields | High correlation |
Recipient Address is highly overall correlated with Channels and 9 other fields | High correlation |
Recipient Address 2 is highly overall correlated with Channels and 12 other fields | High correlation |
Recipient City is highly overall correlated with Channels and 6 other fields | High correlation |
Recipient Country is highly overall correlated with Channels and 8 other fields | High correlation |
Recipient Postal Code is highly overall correlated with Channels and 5 other fields | High correlation |
Fulfillment Type is highly imbalanced (65.1%) | Imbalance |
Recipient Address is highly imbalanced (75.5%) | Imbalance |
Recipient Country is highly imbalanced (51.3%) | Imbalance |
Order Shipping Price has 1401 (100.0%) missing values | Missing |
Order Refunded Amount has 1401 (100.0%) missing values | Missing |
Fulfillment Notes has 1257 (89.7%) missing values | Missing |
Recipient Email has 334 (23.8%) missing values | Missing |
Recipient Address has 1046 (74.7%) missing values | Missing |
Recipient Address 2 has 1362 (97.2%) missing values | Missing |
Recipient Postal Code has 1046 (74.7%) missing values | Missing |
Recipient City has 1046 (74.7%) missing values | Missing |
Recipient Region has 1046 (74.7%) missing values | Missing |
Recipient Country has 1004 (71.7%) missing values | Missing |
Item SKU has 1401 (100.0%) missing values | Missing |
Item Modifiers has 567 (40.5%) missing values | Missing |
Item Quantity is highly skewed (γ1 = 34.03034393) | Skewed |
Order Shipping Price is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Order Refunded Amount is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Item SKU is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Item Price has 15 (1.1%) zeros | Zeros |
Item Options Total Price has 15 (1.1%) zeros | Zeros |
Item Total Price has 15 (1.1%) zeros | Zeros |
Reproduction
| Analysis started | 2024-12-19 01:12:11.347803 |
|---|---|
| Analysis finished | 2024-12-19 01:12:17.293118 |
| Duration | 5.95 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
Variables
Order
Text
| Distinct | 256 |
|---|---|
| Distinct (%) | 18.3% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Memory size | 11.1 KiB |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 15.857857 |
| Min length | 8 |
Unique
| Unique | 59 ? |
|---|---|
| Unique (%) | 4.2% |
Sample
| 1st row | Uber Eats Delivery 8F819 |
|---|---|
| 2nd row | Uber Eats Delivery 8F819 |
| 3rd row | Uber Eats Delivery 8F819 |
| 4th row | Uber Eats Delivery 8F819 |
| 5th row | Uber Eats Delivery 7751A |
| Value | Count | Frequency (%) |
| doordash | 649 | |
| square | 355 | |
| online | 355 | |
| delivery | 310 | |
| eats | 187 | 6.2% |
| uber | 187 | 6.2% |
| postmates | 147 | 4.9% |
| link | 41 | 1.4% |
| payment | 41 | 1.4% |
| pickup | 24 | 0.8% |
| Other values (254) | 710 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 1726 | 7.8% |
| e | 1705 | 7.7% |
| O | 1695 | 7.6% |
| 1606 | 7.2% | |
| S | 1025 | 4.6% |
| r | 852 | 3.8% |
| n | 792 | 3.6% |
| A | 750 | 3.4% |
| a | 730 | 3.3% |
| i | 730 | 3.3% |
| Other values (34) | 10590 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 22201 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| D | 1726 | 7.8% |
| e | 1705 | 7.7% |
| O | 1695 | 7.6% |
| 1606 | 7.2% | |
| S | 1025 | 4.6% |
| r | 852 | 3.8% |
| n | 792 | 3.6% |
| A | 750 | 3.4% |
| a | 730 | 3.3% |
| i | 730 | 3.3% |
| Other values (34) | 10590 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 22201 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| D | 1726 | 7.8% |
| e | 1705 | 7.7% |
| O | 1695 | 7.6% |
| 1606 | 7.2% | |
| S | 1025 | 4.6% |
| r | 852 | 3.8% |
| n | 792 | 3.6% |
| A | 750 | 3.4% |
| a | 730 | 3.3% |
| i | 730 | 3.3% |
| Other values (34) | 10590 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 22201 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| D | 1726 | 7.8% |
| e | 1705 | 7.7% |
| O | 1695 | 7.6% |
| 1606 | 7.2% | |
| S | 1025 | 4.6% |
| r | 852 | 3.8% |
| n | 792 | 3.6% |
| A | 750 | 3.4% |
| a | 730 | 3.3% |
| i | 730 | 3.3% |
| Other values (34) | 10590 |
Order Date
Date
| Distinct | 212 |
|---|---|
| Distinct (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
| Minimum | 2023-12-28 00:00:00 |
|---|---|
| Maximum | 2024-12-18 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Currency
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
| USD |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | USD |
|---|---|
| 2nd row | USD |
| 3rd row | USD |
| 4th row | USD |
| 5th row | USD |
Common Values
| Value | Count | Frequency (%) |
| USD | 1401 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| usd | 1401 |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 1401 | |
| S | 1401 | |
| D | 1401 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4203 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 1401 | |
| S | 1401 | |
| D | 1401 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4203 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 1401 | |
| S | 1401 | |
| D | 1401 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4203 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 1401 | |
| S | 1401 | |
| D | 1401 |
Order Subtotal
Real number (ℝ)
High correlation 
| Distinct | 402 |
|---|---|
| Distinct (%) | 28.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.74571 |
| Minimum | 5.64 |
|---|---|
| Maximum | 1039.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 5.64 |
|---|---|
| 5-th percentile | 19.69 |
| Q1 | 35.92 |
| median | 51.55 |
| Q3 | 74.6 |
| 95-th percentile | 174.26 |
| Maximum | 1039.95 |
| Range | 1034.31 |
| Interquartile range (IQR) | 38.68 |
Descriptive statistics
| Standard deviation | 80.667657 |
|---|---|
| Coefficient of variation (CV) | 1.1565967 |
| Kurtosis | 64.062111 |
| Mean | 69.74571 |
| Median Absolute Deviation (MAD) | 17.09 |
| Skewness | 6.6212974 |
| Sum | 97713.74 |
| Variance | 6507.2709 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 103.15 | 15 | 1.1% |
| 19.99 | 12 | 0.9% |
| 205.01 | 12 | 0.9% |
| 175.44 | 11 | 0.8% |
| 461.07 | 10 | 0.7% |
| 58.04 | 10 | 0.7% |
| 57.86 | 10 | 0.7% |
| 44.27 | 10 | 0.7% |
| 93.28 | 10 | 0.7% |
| 98.22 | 10 | 0.7% |
| Other values (392) | 1291 |
| Value | Count | Frequency (%) |
| 5.64 | 2 | |
| 8.49 | 1 | 0.1% |
| 8.79 | 1 | 0.1% |
| 9.24 | 1 | 0.1% |
| 9.34 | 1 | 0.1% |
| 9.48 | 1 | 0.1% |
| 11.19 | 1 | 0.1% |
| 11.22 | 1 | 0.1% |
| 11.92 | 2 | |
| 13.32 | 4 |
| Value | Count | Frequency (%) |
| 1039.95 | 4 | 0.3% |
| 461.07 | 10 | |
| 450 | 1 | 0.1% |
| 444.85 | 2 | 0.1% |
| 358.35 | 9 | |
| 357.98 | 2 | 0.1% |
| 318.67 | 8 | |
| 259.61 | 1 | 0.1% |
| 211.26 | 3 | 0.2% |
| 205.01 | 12 |
Order Shipping Price
Unsupported
Missing  Rejected  Unsupported 
| Missing | 1401 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 11.1 KiB |
Order Tax Total
Real number (ℝ)
High correlation 
| Distinct | 332 |
|---|---|
| Distinct (%) | 23.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.3773091 |
| Minimum | 0.54 |
|---|---|
| Maximum | 98.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 0.54 |
|---|---|
| 5-th percentile | 1.85 |
| Q1 | 3.03 |
| median | 4.6 |
| Q3 | 6.79 |
| 95-th percentile | 16.08 |
| Maximum | 98.8 |
| Range | 98.26 |
| Interquartile range (IQR) | 3.76 |
Descriptive statistics
| Standard deviation | 7.6664224 |
|---|---|
| Coefficient of variation (CV) | 1.2021406 |
| Kurtosis | 64.795293 |
| Mean | 6.3773091 |
| Median Absolute Deviation (MAD) | 1.72 |
| Skewness | 6.6814653 |
| Sum | 8934.61 |
| Variance | 58.774033 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.46 | 19 | 1.4% |
| 9.32 | 15 | 1.1% |
| 3.32 | 15 | 1.1% |
| 5.23 | 13 | 0.9% |
| 17.86 | 12 | 0.9% |
| 2.94 | 12 | 0.9% |
| 8.09 | 12 | 0.9% |
| 16.38 | 11 | 0.8% |
| 5.04 | 10 | 0.7% |
| 4.21 | 10 | 0.7% |
| Other values (322) | 1272 |
| Value | Count | Frequency (%) |
| 0.54 | 2 | |
| 0.81 | 1 | |
| 0.84 | 1 | |
| 0.88 | 1 | |
| 0.89 | 1 | |
| 0.9 | 1 | |
| 1.06 | 1 | |
| 1.07 | 1 | |
| 1.13 | 2 | |
| 1.19 | 2 |
| Value | Count | Frequency (%) |
| 98.8 | 4 | 0.3% |
| 43.8 | 10 | |
| 42.75 | 1 | 0.1% |
| 42.26 | 2 | 0.1% |
| 34.04 | 9 | |
| 34.01 | 2 | 0.1% |
| 30.27 | 8 | |
| 24.19 | 1 | 0.1% |
| 20.07 | 3 | 0.2% |
| 17.86 | 12 |
Order Total
Real number (ℝ)
High correlation 
| Distinct | 432 |
|---|---|
| Distinct (%) | 30.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.999629 |
| Minimum | 6.18 |
|---|---|
| Maximum | 1158.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 6.18 |
|---|---|
| 5-th percentile | 21.89 |
| Q1 | 38.92 |
| median | 58.19 |
| Q3 | 83.28 |
| 95-th percentile | 191.82 |
| Maximum | 1158.75 |
| Range | 1152.57 |
| Interquartile range (IQR) | 44.36 |
Descriptive statistics
| Standard deviation | 90.501046 |
|---|---|
| Coefficient of variation (CV) | 1.1602753 |
| Kurtosis | 62.219519 |
| Mean | 77.999629 |
| Median Absolute Deviation (MAD) | 20.14 |
| Skewness | 6.5143436 |
| Sum | 109277.48 |
| Variance | 8190.4392 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 112.47 | 15 | 1.1% |
| 243.37 | 12 | 0.9% |
| 191.82 | 11 | 0.8% |
| 63.08 | 10 | 0.7% |
| 48.48 | 10 | 0.7% |
| 107.08 | 10 | 0.7% |
| 21.89 | 10 | 0.7% |
| 101.1 | 10 | 0.7% |
| 504.87 | 10 | 0.7% |
| 42.95 | 9 | 0.6% |
| Other values (422) | 1294 |
| Value | Count | Frequency (%) |
| 6.18 | 2 | |
| 9.3 | 1 | 0.1% |
| 9.63 | 1 | 0.1% |
| 10.12 | 1 | 0.1% |
| 10.23 | 1 | 0.1% |
| 10.38 | 1 | 0.1% |
| 12.25 | 1 | 0.1% |
| 13.41 | 1 | 0.1% |
| 14.59 | 4 | |
| 15.71 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1158.75 | 4 | 0.3% |
| 512.75 | 1 | 0.1% |
| 504.87 | 10 | |
| 487.11 | 2 | 0.1% |
| 427.79 | 2 | 0.1% |
| 412.01 | 9 | |
| 363.94 | 8 | |
| 283.8 | 1 | 0.1% |
| 252.46 | 3 | 0.2% |
| 243.37 | 12 |
Order Refunded Amount
Unsupported
Missing  Rejected  Unsupported 
| Missing | 1401 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 11.1 KiB |
Fulfillment Date
Date
| Distinct | 509 |
|---|---|
| Distinct (%) | 36.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
| Minimum | 2023-12-28 13:30:00 |
|---|---|
| Maximum | 2024-12-18 13:58:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Fulfillment Type
Categorical
High correlation  Imbalance 
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
| Pickup | |
|---|---|
| Curbside | 79 |
| Delivery | 43 |
| Other | 42 |
Length
| Max length | 8 |
|---|---|
| Median length | 6 |
| Mean length | 6.1441827 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Pickup |
|---|---|
| 2nd row | Pickup |
| 3rd row | Pickup |
| 4th row | Pickup |
| 5th row | Pickup |
Common Values
| Value | Count | Frequency (%) |
| Pickup | 1237 | |
| Curbside | 79 | 5.6% |
| Delivery | 43 | 3.1% |
| Other | 42 | 3.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pickup | 1237 | |
| curbside | 79 | 5.6% |
| delivery | 43 | 3.1% |
| other | 42 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 1359 | |
| u | 1316 | |
| P | 1237 | |
| c | 1237 | |
| k | 1237 | |
| p | 1237 | |
| e | 207 | 2.4% |
| r | 164 | 1.9% |
| C | 79 | 0.9% |
| s | 79 | 0.9% |
| Other values (9) | 456 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 8608 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| i | 1359 | |
| u | 1316 | |
| P | 1237 | |
| c | 1237 | |
| k | 1237 | |
| p | 1237 | |
| e | 207 | 2.4% |
| r | 164 | 1.9% |
| C | 79 | 0.9% |
| s | 79 | 0.9% |
| Other values (9) | 456 | 5.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 8608 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| i | 1359 | |
| u | 1316 | |
| P | 1237 | |
| c | 1237 | |
| k | 1237 | |
| p | 1237 | |
| e | 207 | 2.4% |
| r | 164 | 1.9% |
| C | 79 | 0.9% |
| s | 79 | 0.9% |
| Other values (9) | 456 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 8608 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| i | 1359 | |
| u | 1316 | |
| P | 1237 | |
| c | 1237 | |
| k | 1237 | |
| p | 1237 | |
| e | 207 | 2.4% |
| r | 164 | 1.9% |
| C | 79 | 0.9% |
| s | 79 | 0.9% |
| Other values (9) | 456 | 5.3% |
Fulfillment Status
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
| Completed |
|---|
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Completed |
|---|---|
| 2nd row | Completed |
| 3rd row | Completed |
| 4th row | Completed |
| 5th row | Completed |
Common Values
| Value | Count | Frequency (%) |
| Completed | 1401 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| completed | 1401 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 2802 | |
| C | 1401 | |
| m | 1401 | |
| o | 1401 | |
| p | 1401 | |
| l | 1401 | |
| t | 1401 | |
| d | 1401 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 12609 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 2802 | |
| C | 1401 | |
| m | 1401 | |
| o | 1401 | |
| p | 1401 | |
| l | 1401 | |
| t | 1401 | |
| d | 1401 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 12609 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 2802 | |
| C | 1401 | |
| m | 1401 | |
| o | 1401 | |
| p | 1401 | |
| l | 1401 | |
| t | 1401 | |
| d | 1401 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 12609 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 2802 | |
| C | 1401 | |
| m | 1401 | |
| o | 1401 | |
| p | 1401 | |
| l | 1401 | |
| t | 1401 | |
| d | 1401 |
Channels
Categorical
High correlation 
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
| DoorDash | |
|---|---|
| BELLY RUBB | BBQ Catering | Barbecue To Go and Delivery | |
| Postmates Delivery | |
| Payment Links | 41 |
| Belly Rubb | 1 |
Length
| Max length | 55 |
|---|---|
| Median length | 18 |
| Mean length | 22.441113 |
| Min length | 8 |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Postmates Delivery |
|---|---|
| 2nd row | Postmates Delivery |
| 3rd row | Postmates Delivery |
| 4th row | Postmates Delivery |
| 5th row | Postmates Delivery |
Common Values
| Value | Count | Frequency (%) |
| DoorDash | 670 | |
| BELLY RUBB | BBQ Catering | Barbecue To Go and Delivery | 355 | |
| Postmates Delivery | 334 | |
| Payment Links | 41 | 2.9% |
| Belly Rubb | 1 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 710 | ||
| delivery | 689 | |
| doordash | 670 | |
| belly | 356 | |
| rubb | 356 | |
| bbq | 355 | |
| catering | 355 | |
| barbecue | 355 | |
| go | 355 | |
| to | 355 | |
| Other values (4) | 771 |
Most occurring characters
| Value | Count | Frequency (%) |
| 3926 | 12.5% | |
| e | 2819 | 9.0% |
| o | 2384 | 7.6% |
| B | 2131 | 6.8% |
| a | 2110 | 6.7% |
| r | 2069 | 6.6% |
| D | 2029 | 6.5% |
| s | 1379 | 4.4% |
| i | 1085 | 3.5% |
| t | 1064 | 3.4% |
| Other values (23) | 10444 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 31440 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3926 | 12.5% | |
| e | 2819 | 9.0% |
| o | 2384 | 7.6% |
| B | 2131 | 6.8% |
| a | 2110 | 6.7% |
| r | 2069 | 6.6% |
| D | 2029 | 6.5% |
| s | 1379 | 4.4% |
| i | 1085 | 3.5% |
| t | 1064 | 3.4% |
| Other values (23) | 10444 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 31440 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3926 | 12.5% | |
| e | 2819 | 9.0% |
| o | 2384 | 7.6% |
| B | 2131 | 6.8% |
| a | 2110 | 6.7% |
| r | 2069 | 6.6% |
| D | 2029 | 6.5% |
| s | 1379 | 4.4% |
| i | 1085 | 3.5% |
| t | 1064 | 3.4% |
| Other values (23) | 10444 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 31440 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3926 | 12.5% | |
| e | 2819 | 9.0% |
| o | 2384 | 7.6% |
| B | 2131 | 6.8% |
| a | 2110 | 6.7% |
| r | 2069 | 6.6% |
| D | 2029 | 6.5% |
| s | 1379 | 4.4% |
| i | 1085 | 3.5% |
| t | 1064 | 3.4% |
| Other values (23) | 10444 |
Fulfillment Location
Categorical
Constant 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
| Belly Rubb |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Belly Rubb |
|---|---|
| 2nd row | Belly Rubb |
| 3rd row | Belly Rubb |
| 4th row | Belly Rubb |
| 5th row | Belly Rubb |
Common Values
| Value | Count | Frequency (%) |
| Belly Rubb | 1401 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| belly | 1401 | |
| rubb | 1401 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 2802 | |
| b | 2802 | |
| e | 1401 | |
| B | 1401 | |
| y | 1401 | |
| 1401 | ||
| R | 1401 | |
| u | 1401 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 14010 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 2802 | |
| b | 2802 | |
| e | 1401 | |
| B | 1401 | |
| y | 1401 | |
| 1401 | ||
| R | 1401 | |
| u | 1401 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 14010 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 2802 | |
| b | 2802 | |
| e | 1401 | |
| B | 1401 | |
| y | 1401 | |
| 1401 | ||
| R | 1401 | |
| u | 1401 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 14010 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 2802 | |
| b | 2802 | |
| e | 1401 | |
| B | 1401 | |
| y | 1401 | |
| 1401 | ||
| R | 1401 | |
| u | 1401 |
Missing 
| Distinct | 52 |
|---|---|
| Distinct (%) | 36.1% |
| Missing | 1257 |
| Missing (%) | 89.7% |
| Memory size | 11.1 KiB |
Length
| Max length | 396 |
|---|---|
| Median length | 182 |
| Mean length | 108.0625 |
| Min length | 12 |
Unique
| Unique | 14 ? |
|---|---|
| Unique (%) | 9.7% |
Sample
| 1st row | CURBSIDE PICKUP - DETAILS: White Chrysler minivan |
|---|---|
| 2nd row | No Contact Order. Delivery Instructions: PLEASE CALL 818 912 3845 Juan Jose Munoz will answer Delivery By Doordash. Courier pickup time: 11/28/2024 3:35pm - 3:45pm. For issues, contact 1(855) 222-8111 and provide the following delivery ID: 2376523971. Total Fees Applied: $17,29 |
| 3rd row | Forks please |
| 4th row | Forks please |
| 5th row | Forks please |
| Value | Count | Frequency (%) |
| 139 | 5.7% | |
| pickup | 124 | 5.1% |
| delivery | 104 | 4.2% |
| the | 93 | 3.8% |
| curbside | 79 | 3.2% |
| and | 72 | 2.9% |
| details | 70 | 2.9% |
| for | 52 | 2.1% |
| issues | 48 | 2.0% |
| contact | 47 | 1.9% |
| Other values (247) | 1624 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2236 | 14.4% | |
| e | 1019 | 6.5% |
| o | 633 | 4.1% |
| i | 623 | 4.0% |
| a | 606 | 3.9% |
| r | 555 | 3.6% |
| t | 515 | 3.3% |
| s | 485 | 3.1% |
| l | 485 | 3.1% |
| n | 405 | 2.6% |
| Other values (65) | 7999 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15561 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2236 | 14.4% | |
| e | 1019 | 6.5% |
| o | 633 | 4.1% |
| i | 623 | 4.0% |
| a | 606 | 3.9% |
| r | 555 | 3.6% |
| t | 515 | 3.3% |
| s | 485 | 3.1% |
| l | 485 | 3.1% |
| n | 405 | 2.6% |
| Other values (65) | 7999 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15561 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2236 | 14.4% | |
| e | 1019 | 6.5% |
| o | 633 | 4.1% |
| i | 623 | 4.0% |
| a | 606 | 3.9% |
| r | 555 | 3.6% |
| t | 515 | 3.3% |
| s | 485 | 3.1% |
| l | 485 | 3.1% |
| n | 405 | 2.6% |
| Other values (65) | 7999 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15561 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2236 | 14.4% | |
| e | 1019 | 6.5% |
| o | 633 | 4.1% |
| i | 623 | 4.0% |
| a | 606 | 3.9% |
| r | 555 | 3.6% |
| t | 515 | 3.3% |
| s | 485 | 3.1% |
| l | 485 | 3.1% |
| n | 405 | 2.6% |
| Other values (65) | 7999 |
Recipient Name
Text
| Distinct | 367 |
|---|---|
| Distinct (%) | 26.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
Length
| Max length | 23 |
|---|---|
| Median length | 18 |
| Mean length | 11.127052 |
| Min length | 4 |
Unique
| Unique | 71 ? |
|---|---|
| Unique (%) | 5.1% |
Sample
| 1st row | 8F819-Diana O. |
|---|---|
| 2nd row | 8F819-Diana O. |
| 3rd row | 8F819-Diana O. |
| 4th row | 8F819-Diana O. |
| 5th row | 7751A-Lilit A. |
| Value | Count | Frequency (%) |
| s | 125 | 4.4% |
| d | 71 | 2.5% |
| k | 71 | 2.5% |
| b | 71 | 2.5% |
| c | 68 | 2.4% |
| m | 66 | 2.3% |
| a | 66 | 2.3% |
| o | 63 | 2.2% |
| g | 54 | 1.9% |
| l | 53 | 1.9% |
| Other values (434) | 2108 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1415 | 9.1% | |
| a | 1308 | 8.4% |
| e | 1059 | 6.8% |
| n | 961 | 6.2% |
| i | 728 | 4.7% |
| r | 706 | 4.5% |
| o | 542 | 3.5% |
| l | 486 | 3.1% |
| - | 382 | 2.5% |
| A | 376 | 2.4% |
| Other values (54) | 7626 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 15589 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1415 | 9.1% | |
| a | 1308 | 8.4% |
| e | 1059 | 6.8% |
| n | 961 | 6.2% |
| i | 728 | 4.7% |
| r | 706 | 4.5% |
| o | 542 | 3.5% |
| l | 486 | 3.1% |
| - | 382 | 2.5% |
| A | 376 | 2.4% |
| Other values (54) | 7626 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 15589 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1415 | 9.1% | |
| a | 1308 | 8.4% |
| e | 1059 | 6.8% |
| n | 961 | 6.2% |
| i | 728 | 4.7% |
| r | 706 | 4.5% |
| o | 542 | 3.5% |
| l | 486 | 3.1% |
| - | 382 | 2.5% |
| A | 376 | 2.4% |
| Other values (54) | 7626 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 15589 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1415 | 9.1% | |
| a | 1308 | 8.4% |
| e | 1059 | 6.8% |
| n | 961 | 6.2% |
| i | 728 | 4.7% |
| r | 706 | 4.5% |
| o | 542 | 3.5% |
| l | 486 | 3.1% |
| - | 382 | 2.5% |
| A | 376 | 2.4% |
| Other values (54) | 7626 |
Recipient Email
Text
Missing 
| Distinct | 97 |
|---|---|
| Distinct (%) | 9.1% |
| Missing | 334 |
| Missing (%) | 23.8% |
| Memory size | 11.1 KiB |
Length
| Max length | 38 |
|---|---|
| Median length | 38 |
| Mean length | 32 |
| Min length | 13 |
Unique
| Unique | 21 ? |
|---|---|
| Unique (%) | 2.0% |
Sample
| 1st row | point-of-sale-integration@doordash.com |
|---|---|
| 2nd row | point-of-sale-integration@doordash.com |
| 3rd row | point-of-sale-integration@doordash.com |
| 4th row | point-of-sale-integration@doordash.com |
| 5th row | point-of-sale-integration@doordash.com |
| Value | Count | Frequency (%) |
| point-of-sale-integration@doordash.com | 670 | |
| alex.anthony.diaz@gmail.com | 31 | 2.9% |
| steven.trella@gmail.com | 28 | 2.6% |
| mogshut@gmail.com | 28 | 2.6% |
| bidium@gmail.com | 22 | 2.1% |
| monalapides@gmail.com | 12 | 1.1% |
| m.m.keshishyan@gmail.com | 11 | 1.0% |
| strwbrytiff@yahoo.com | 10 | 0.9% |
| narumol2003@yahoo.com | 8 | 0.7% |
| thomsteltime@gmail.com | 7 | 0.7% |
| Other values (87) | 240 | 22.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 4769 | |
| a | 2878 | 8.4% |
| i | 2607 | 7.6% |
| n | 2388 | 7.0% |
| t | 2292 | 6.7% |
| - | 2010 | 5.9% |
| e | 1783 | 5.2% |
| r | 1618 | 4.7% |
| s | 1548 | 4.5% |
| m | 1545 | 4.5% |
| Other values (45) | 10706 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 34144 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 4769 | |
| a | 2878 | 8.4% |
| i | 2607 | 7.6% |
| n | 2388 | 7.0% |
| t | 2292 | 6.7% |
| - | 2010 | 5.9% |
| e | 1783 | 5.2% |
| r | 1618 | 4.7% |
| s | 1548 | 4.5% |
| m | 1545 | 4.5% |
| Other values (45) | 10706 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 34144 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 4769 | |
| a | 2878 | 8.4% |
| i | 2607 | 7.6% |
| n | 2388 | 7.0% |
| t | 2292 | 6.7% |
| - | 2010 | 5.9% |
| e | 1783 | 5.2% |
| r | 1618 | 4.7% |
| s | 1548 | 4.5% |
| m | 1545 | 4.5% |
| Other values (45) | 10706 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 34144 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 4769 | |
| a | 2878 | 8.4% |
| i | 2607 | 7.6% |
| n | 2388 | 7.0% |
| t | 2292 | 6.7% |
| - | 2010 | 5.9% |
| e | 1783 | 5.2% |
| r | 1618 | 4.7% |
| s | 1548 | 4.5% |
| m | 1545 | 4.5% |
| Other values (45) | 10706 |
Recipient Phone
Text
| Distinct | 95 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.1 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 12 |
| Mean length | 11.810136 |
| Min length | 10 |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | 1.4% |
Sample
| 1st row | +1 312-766-6835 |
|---|---|
| 2nd row | +1 312-766-6835 |
| 3rd row | +1 312-766-6835 |
| 4th row | +1 312-766-6835 |
| 5th row | +1 312-766-6835 |
| Value | Count | Frequency (%) |
| 1 | 358 | |
| 8552228111 | 357 | |
| 312-766-6835 | 334 | |
| 8559731040 | 313 | |
| 16268647315 | 35 | 2.0% |
| 16266164211 | 31 | 1.8% |
| 18184862439 | 28 | 1.6% |
| 818-822-5060 | 22 | 1.3% |
| 18186360644 | 12 | 0.7% |
| 17472562597 | 11 | 0.6% |
| Other values (86) | 258 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2978 | |
| 5 | 1985 | |
| 8 | 1979 | |
| 2 | 1864 | |
| 6 | 1632 | |
| 3 | 1308 | |
| 7 | 930 | 5.6% |
| 0 | 866 | 5.2% |
| + | 731 | 4.4% |
| - | 716 | 4.3% |
| Other values (3) | 1557 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16546 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2978 | |
| 5 | 1985 | |
| 8 | 1979 | |
| 2 | 1864 | |
| 6 | 1632 | |
| 3 | 1308 | |
| 7 | 930 | 5.6% |
| 0 | 866 | 5.2% |
| + | 731 | 4.4% |
| - | 716 | 4.3% |
| Other values (3) | 1557 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16546 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2978 | |
| 5 | 1985 | |
| 8 | 1979 | |
| 2 | 1864 | |
| 6 | 1632 | |
| 3 | 1308 | |
| 7 | 930 | 5.6% |
| 0 | 866 | 5.2% |
| + | 731 | 4.4% |
| - | 716 | 4.3% |
| Other values (3) | 1557 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16546 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2978 | |
| 5 | 1985 | |
| 8 | 1979 | |
| 2 | 1864 | |
| 6 | 1632 | |
| 3 | 1308 | |
| 7 | 930 | 5.6% |
| 0 | 866 | 5.2% |
| + | 731 | 4.4% |
| - | 716 | 4.3% |
| Other values (3) | 1557 |
Recipient Address
Categorical
High correlation  Imbalance  Missing 
| Distinct | 15 |
|---|---|
| Distinct (%) | 4.2% |
| Missing | 1046 |
| Missing (%) | 74.7% |
| Memory size | 11.1 KiB |
| 13346 Saticoy St | |
|---|---|
| 6615 Sepulveda Boulevard | 9 |
| 15447 Tupper Street | 5 |
| 15825 Saticoy Street | 5 |
| 5447 Matilija Avenue | 4 |
| Other values (10) | 20 |
Length
| Max length | 24 |
|---|---|
| Median length | 16 |
| Mean length | 16.63662 |
| Min length | 16 |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 1.1% |
Sample
| 1st row | 13346 Saticoy St |
|---|---|
| 2nd row | 13346 Saticoy St |
| 3rd row | 13346 Saticoy St |
| 4th row | 13346 Saticoy St |
| 5th row | 13346 Saticoy St |
Common Values
| Value | Count | Frequency (%) |
| 13346 Saticoy St | 312 | 22.3% |
| 6615 Sepulveda Boulevard | 9 | 0.6% |
| 15447 Tupper Street | 5 | 0.4% |
| 15825 Saticoy Street | 5 | 0.4% |
| 5447 Matilija Avenue | 4 | 0.3% |
| 12320 Burbank Boulevard | 3 | 0.2% |
| 6230 Van Nuys Boulevard | 3 | 0.2% |
| 13244 Arminta Street | 3 | 0.2% |
| 7636 Fulton Avenue | 3 | 0.2% |
| 9017 Greenbush Avenue | 2 | 0.1% |
| Other values (5) | 6 | 0.4% |
| (Missing) | 1046 |
Length
| Value | Count | Frequency (%) |
| saticoy | 317 | |
| 13346 | 312 | |
| st | 312 | |
| boulevard | 18 | 1.7% |
| street | 14 | 1.3% |
| avenue | 11 | 1.0% |
| sepulveda | 9 | 0.8% |
| 6615 | 9 | 0.8% |
| 15447 | 5 | 0.5% |
| tupper | 5 | 0.5% |
| Other values (23) | 58 | 5.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 715 | ||
| t | 670 | |
| S | 652 | |
| 3 | 639 | |
| a | 365 | 6.2% |
| 1 | 342 | 5.8% |
| o | 342 | 5.8% |
| 6 | 341 | 5.8% |
| 4 | 337 | 5.7% |
| i | 330 | 5.6% |
| Other values (35) | 1173 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5906 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 715 | ||
| t | 670 | |
| S | 652 | |
| 3 | 639 | |
| a | 365 | 6.2% |
| 1 | 342 | 5.8% |
| o | 342 | 5.8% |
| 6 | 341 | 5.8% |
| 4 | 337 | 5.7% |
| i | 330 | 5.6% |
| Other values (35) | 1173 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5906 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 715 | ||
| t | 670 | |
| S | 652 | |
| 3 | 639 | |
| a | 365 | 6.2% |
| 1 | 342 | 5.8% |
| o | 342 | 5.8% |
| 6 | 341 | 5.8% |
| 4 | 337 | 5.7% |
| i | 330 | 5.6% |
| Other values (35) | 1173 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5906 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 715 | ||
| t | 670 | |
| S | 652 | |
| 3 | 639 | |
| a | 365 | 6.2% |
| 1 | 342 | 5.8% |
| o | 342 | 5.8% |
| 6 | 341 | 5.8% |
| 4 | 337 | 5.7% |
| i | 330 | 5.6% |
| Other values (35) | 1173 |
Recipient Address 2
Categorical
High correlation  Missing 
| Distinct | 7 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 1362 |
| Missing (%) | 97.2% |
| Memory size | 11.1 KiB |
| unit 1 | |
|---|---|
| 104 | |
| 25 | |
| 123 | |
| Apt 314 | |
| Other values (2) |
Length
| Max length | 14 |
|---|---|
| Median length | 7 |
| Mean length | 4.7692308 |
| Min length | 2 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 5.1% |
Sample
| 1st row | 214 |
|---|---|
| 2nd row | 104 |
| 3rd row | 104 |
| 4th row | 104 |
| 5th row | 104 |
Common Values
| Value | Count | Frequency (%) |
| unit 1 | 17 | 1.2% |
| 104 | 9 | 0.6% |
| 25 | 5 | 0.4% |
| 123 | 3 | 0.2% |
| Apt 314 | 3 | 0.2% |
| 214 | 1 | 0.1% |
| Leasing office | 1 | 0.1% |
| (Missing) | 1362 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| unit | 17 | |
| 1 | 17 | |
| 104 | 9 | |
| 25 | 5 | 8.3% |
| 123 | 3 | 5.0% |
| apt | 3 | 5.0% |
| 314 | 3 | 5.0% |
| 214 | 1 | 1.7% |
| leasing | 1 | 1.7% |
| office | 1 | 1.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 33 | |
| 21 | ||
| t | 20 | |
| i | 19 | |
| n | 18 | |
| u | 17 | |
| 4 | 13 | 7.0% |
| 0 | 9 | 4.8% |
| 2 | 9 | 4.8% |
| 3 | 6 | 3.2% |
| Other values (11) | 21 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 186 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 33 | |
| 21 | ||
| t | 20 | |
| i | 19 | |
| n | 18 | |
| u | 17 | |
| 4 | 13 | 7.0% |
| 0 | 9 | 4.8% |
| 2 | 9 | 4.8% |
| 3 | 6 | 3.2% |
| Other values (11) | 21 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 186 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 33 | |
| 21 | ||
| t | 20 | |
| i | 19 | |
| n | 18 | |
| u | 17 | |
| 4 | 13 | 7.0% |
| 0 | 9 | 4.8% |
| 2 | 9 | 4.8% |
| 3 | 6 | 3.2% |
| Other values (11) | 21 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 186 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 33 | |
| 21 | ||
| t | 20 | |
| i | 19 | |
| n | 18 | |
| u | 17 | |
| 4 | 13 | 7.0% |
| 0 | 9 | 4.8% |
| 2 | 9 | 4.8% |
| 3 | 6 | 3.2% |
| Other values (11) | 21 |
Recipient Postal Code
Real number (ℝ)
High correlation  Missing 
| Distinct | 11 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 1046 |
| Missing (%) | 74.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 91586.335 |
| Minimum | 91331 |
|---|---|
| Maximum | 91607 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 91331 |
|---|---|
| 5-th percentile | 91406 |
| Q1 | 91605 |
| median | 91605 |
| Q3 | 91605 |
| 95-th percentile | 91605 |
| Maximum | 91607 |
| Range | 276 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 61.040394 |
|---|---|
| Coefficient of variation (CV) | 0.00066647927 |
| Kurtosis | 7.6206666 |
| Mean | 91586.335 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -3.0454406 |
| Sum | 32513149 |
| Variance | 3725.9297 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91605 | 318 | 22.7% |
| 91411 | 9 | 0.6% |
| 91401 | 7 | 0.5% |
| 91406 | 5 | 0.4% |
| 91343 | 5 | 0.4% |
| 91607 | 3 | 0.2% |
| 91606 | 2 | 0.1% |
| 91405 | 2 | 0.1% |
| 91331 | 2 | 0.1% |
| 91601 | 1 | 0.1% |
| (Missing) | 1046 |
| Value | Count | Frequency (%) |
| 91331 | 2 | 0.1% |
| 91343 | 5 | 0.4% |
| 91401 | 7 | 0.5% |
| 91402 | 1 | 0.1% |
| 91405 | 2 | 0.1% |
| 91406 | 5 | 0.4% |
| 91411 | 9 | 0.6% |
| 91601 | 1 | 0.1% |
| 91605 | 318 | |
| 91606 | 2 | 0.1% |
| Value | Count | Frequency (%) |
| 91607 | 3 | 0.2% |
| 91606 | 2 | 0.1% |
| 91605 | 318 | |
| 91601 | 1 | 0.1% |
| 91411 | 9 | 0.6% |
| 91406 | 5 | 0.4% |
| 91405 | 2 | 0.1% |
| 91402 | 1 | 0.1% |
| 91401 | 7 | 0.5% |
| 91343 | 5 | 0.4% |
Recipient City
Categorical
High correlation  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 1046 |
| Missing (%) | 74.7% |
| Memory size | 11.1 KiB |
| North Hollywood | |
|---|---|
| Los Angeles |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 14.323944 |
| Min length | 11 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | North Hollywood |
|---|---|
| 2nd row | North Hollywood |
| 3rd row | North Hollywood |
| 4th row | North Hollywood |
| 5th row | North Hollywood |
Common Values
| Value | Count | Frequency (%) |
| North Hollywood | 295 | 21.1% |
| Los Angeles | 60 | 4.3% |
| (Missing) | 1046 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| north | 295 | |
| hollywood | 295 | |
| los | 60 | 8.5% |
| angeles | 60 | 8.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 1240 | |
| l | 650 | |
| 355 | 7.0% | |
| N | 295 | 5.8% |
| r | 295 | 5.8% |
| h | 295 | 5.8% |
| t | 295 | 5.8% |
| H | 295 | 5.8% |
| y | 295 | 5.8% |
| w | 295 | 5.8% |
| Other values (7) | 775 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5085 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 1240 | |
| l | 650 | |
| 355 | 7.0% | |
| N | 295 | 5.8% |
| r | 295 | 5.8% |
| h | 295 | 5.8% |
| t | 295 | 5.8% |
| H | 295 | 5.8% |
| y | 295 | 5.8% |
| w | 295 | 5.8% |
| Other values (7) | 775 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5085 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 1240 | |
| l | 650 | |
| 355 | 7.0% | |
| N | 295 | 5.8% |
| r | 295 | 5.8% |
| h | 295 | 5.8% |
| t | 295 | 5.8% |
| H | 295 | 5.8% |
| y | 295 | 5.8% |
| w | 295 | 5.8% |
| Other values (7) | 775 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5085 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 1240 | |
| l | 650 | |
| 355 | 7.0% | |
| N | 295 | 5.8% |
| r | 295 | 5.8% |
| h | 295 | 5.8% |
| t | 295 | 5.8% |
| H | 295 | 5.8% |
| y | 295 | 5.8% |
| w | 295 | 5.8% |
| Other values (7) | 775 |
Recipient Region
Categorical
Constant  Missing 
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 1046 |
| Missing (%) | 74.7% |
| Memory size | 11.1 KiB |
| CA |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CA |
|---|---|
| 2nd row | CA |
| 3rd row | CA |
| 4th row | CA |
| 5th row | CA |
Common Values
| Value | Count | Frequency (%) |
| CA | 355 | 25.3% |
| (Missing) | 1046 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ca | 355 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 355 | |
| A | 355 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 710 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 355 | |
| A | 355 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 710 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 355 | |
| A | 355 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 710 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 355 | |
| A | 355 |
Recipient Country
Categorical
High correlation  Imbalance  Missing 
| Distinct | 2 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 1004 |
| Missing (%) | 71.7% |
| Memory size | 11.1 KiB |
| US | |
|---|---|
| ZZ |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
Common Values
| Value | Count | Frequency (%) |
| US | 355 | 25.3% |
| ZZ | 42 | 3.0% |
| (Missing) | 1004 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| us | 355 | |
| zz | 42 | 10.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 355 | |
| S | 355 | |
| Z | 84 | 10.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 794 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| U | 355 | |
| S | 355 | |
| Z | 84 | 10.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 794 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| U | 355 | |
| S | 355 | |
| Z | 84 | 10.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 794 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| U | 355 | |
| S | 355 | |
| Z | 84 | 10.6% |
Item Quantity
Real number (ℝ)
High correlation  Skewed 
| Distinct | 13 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.276945 |
| Minimum | 1 |
|---|---|
| Maximum | 130 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 130 |
| Range | 129 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.5579434 |
|---|---|
| Coefficient of variation (CV) | 2.7862933 |
| Kurtosis | 1226.54 |
| Mean | 1.276945 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 34.030344 |
| Sum | 1789 |
| Variance | 12.658961 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 1265 | |
| 2 | 96 | 6.9% |
| 3 | 13 | 0.9% |
| 4 | 13 | 0.9% |
| 5 | 4 | 0.3% |
| 15 | 2 | 0.1% |
| 6 | 2 | 0.1% |
| 8 | 1 | 0.1% |
| 11 | 1 | 0.1% |
| 14 | 1 | 0.1% |
| Other values (3) | 3 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 1265 | |
| 2 | 96 | 6.9% |
| 3 | 13 | 0.9% |
| 4 | 13 | 0.9% |
| 5 | 4 | 0.3% |
| 6 | 2 | 0.1% |
| 7 | 1 | 0.1% |
| 8 | 1 | 0.1% |
| 9 | 1 | 0.1% |
| 11 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 130 | 1 | 0.1% |
| 15 | 2 | 0.1% |
| 14 | 1 | 0.1% |
| 11 | 1 | 0.1% |
| 9 | 1 | 0.1% |
| 8 | 1 | 0.1% |
| 7 | 1 | 0.1% |
| 6 | 2 | 0.1% |
| 5 | 4 | 0.3% |
| 4 | 13 |
Item Name
Text
| Distinct | 75 |
|---|---|
| Distinct (%) | 5.4% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Memory size | 11.1 KiB |
Length
| Max length | 31 |
|---|---|
| Median length | 25 |
| Mean length | 17.597857 |
| Min length | 7 |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | 0.9% |
Sample
| 1st row | CRISPY CHICKEN SANDWICH |
|---|---|
| 2nd row | LOADED FRIES |
| 3rd row | CREAMY BLUE CHEESE DIP |
| 4th row | ARTISAN MAC AND CHEESE |
| 5th row | BEEF SHORT RIB |
| Value | Count | Frequency (%) |
| back | 284 | 6.6% |
| baby | 280 | 6.6% |
| ribs | 218 | 5.1% |
| belly | 166 | 3.9% |
| pork | 165 | 3.9% |
| glazed | 165 | 3.9% |
| fries | 148 | 3.5% |
| combo | 143 | 3.3% |
| rib | 139 | 3.3% |
| beef | 118 | 2.8% |
| Other values (100) | 2446 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2872 | 11.7% | |
| E | 2260 | 9.2% |
| B | 1922 | 7.8% |
| A | 1845 | 7.5% |
| S | 1487 | 6.0% |
| R | 1413 | 5.7% |
| I | 1405 | 5.7% |
| C | 1391 | 5.6% |
| L | 1114 | 4.5% |
| O | 981 | 4.0% |
| Other values (55) | 7947 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 24637 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2872 | 11.7% | |
| E | 2260 | 9.2% |
| B | 1922 | 7.8% |
| A | 1845 | 7.5% |
| S | 1487 | 6.0% |
| R | 1413 | 5.7% |
| I | 1405 | 5.7% |
| C | 1391 | 5.6% |
| L | 1114 | 4.5% |
| O | 981 | 4.0% |
| Other values (55) | 7947 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 24637 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2872 | 11.7% | |
| E | 2260 | 9.2% |
| B | 1922 | 7.8% |
| A | 1845 | 7.5% |
| S | 1487 | 6.0% |
| R | 1413 | 5.7% |
| I | 1405 | 5.7% |
| C | 1391 | 5.6% |
| L | 1114 | 4.5% |
| O | 981 | 4.0% |
| Other values (55) | 7947 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 24637 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2872 | 11.7% | |
| E | 2260 | 9.2% |
| B | 1922 | 7.8% |
| A | 1845 | 7.5% |
| S | 1487 | 6.0% |
| R | 1413 | 5.7% |
| I | 1405 | 5.7% |
| C | 1391 | 5.6% |
| L | 1114 | 4.5% |
| O | 981 | 4.0% |
| Other values (55) | 7947 |
Item SKU
Unsupported
Missing  Rejected  Unsupported 
| Missing | 1401 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 11.1 KiB |
Item Variation
Categorical
| Distinct | 25 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 1 |
| Missing (%) | 0.1% |
| Memory size | 11.1 KiB |
| Regular | |
|---|---|
| Full Rack | |
| Side | |
| Full | |
| 4 Bites | |
| Other values (20) |
Length
| Max length | 39 |
|---|---|
| Median length | 7 |
| Mean length | 6.9221429 |
| Min length | 4 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | Regular |
|---|---|
| 2nd row | Regular |
| 3rd row | Regular |
| 4th row | Side |
| 5th row | Regular |
Common Values
| Value | Count | Frequency (%) |
| Regular | 721 | |
| Full Rack | 129 | 9.2% |
| Side | 115 | 8.2% |
| Full | 100 | 7.1% |
| 4 Bites | 80 | 5.7% |
| Half rack | 52 | 3.7% |
| 6 pcs | 51 | 3.6% |
| 8 pcs | 26 | 1.9% |
| 12 pcs | 25 | 1.8% |
| 2 sliders | 23 | 1.6% |
| Other values (15) | 78 | 5.6% |
Length
| Value | Count | Frequency (%) |
| regular | 721 | |
| full | 236 | 12.5% |
| rack | 181 | 9.6% |
| side | 129 | 6.8% |
| pcs | 120 | 6.4% |
| bites | 101 | 5.3% |
| 4 | 90 | 4.8% |
| 6 | 58 | 3.1% |
| half | 54 | 2.9% |
| sliders | 35 | 1.9% |
| Other values (13) | 163 | 8.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 1307 | |
| e | 1042 | |
| a | 984 | |
| u | 969 | |
| R | 863 | |
| r | 848 | |
| g | 721 | 7.4% |
| 488 | 5.0% | |
| s | 316 | 3.3% |
| c | 302 | 3.1% |
| Other values (29) | 1851 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 9691 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 1307 | |
| e | 1042 | |
| a | 984 | |
| u | 969 | |
| R | 863 | |
| r | 848 | |
| g | 721 | 7.4% |
| 488 | 5.0% | |
| s | 316 | 3.3% |
| c | 302 | 3.1% |
| Other values (29) | 1851 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 9691 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 1307 | |
| e | 1042 | |
| a | 984 | |
| u | 969 | |
| R | 863 | |
| r | 848 | |
| g | 721 | 7.4% |
| 488 | 5.0% | |
| s | 316 | 3.3% |
| c | 302 | 3.1% |
| Other values (29) | 1851 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 9691 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 1307 | |
| e | 1042 | |
| a | 984 | |
| u | 969 | |
| R | 863 | |
| r | 848 | |
| g | 721 | 7.4% |
| 488 | 5.0% | |
| s | 316 | 3.3% |
| c | 302 | 3.1% |
| Other values (29) | 1851 |
Item Modifiers
Text
Missing 
| Distinct | 393 |
|---|---|
| Distinct (%) | 47.1% |
| Missing | 567 |
| Missing (%) | 40.5% |
| Memory size | 11.1 KiB |
Length
| Max length | 236 |
|---|---|
| Median length | 145.5 |
| Mean length | 56.443645 |
| Min length | 11 |
Unique
| Unique | 300 ? |
|---|---|
| Unique (%) | 36.0% |
Sample
| 1st row | 1 x Signature BBQ Sauce Drizzle, 1 x Salt and Pepper |
|---|---|
| 2nd row | 1 x Lemon Pepper |
| 3rd row | 1 x Sprite ™, 1 x Mac & Cheese, 1 x Rosemary Pepper Fries, 1 x Sweet&Spicy Glaze, 1 x Boom-Boom Sauce DIp |
| 4th row | 1 x Boom-Boom Sauce DIp, 1 x Sweet and Spicy BBQ Sauce Dip |
| 5th row | 1 x Signature BBQ Sauce Drizzle, 1 x Salt and Pepper |
| Value | Count | Frequency (%) |
| 1 | 1928 | |
| x | 1928 | |
| bbq | 518 | 5.2% |
| glaze | 453 | 4.5% |
| signature | 419 | 4.2% |
| sauce | 291 | 2.9% |
| dip | 286 | 2.9% |
| pepper | 259 | 2.6% |
| no | 176 | 1.8% |
| salt | 141 | 1.4% |
| Other values (112) | 3631 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9196 | ||
| e | 4557 | 9.7% |
| a | 2878 | 6.1% |
| x | 1977 | 4.2% |
| 1 | 1928 | 4.1% |
| p | 1668 | 3.5% |
| l | 1565 | 3.3% |
| i | 1555 | 3.3% |
| r | 1551 | 3.3% |
| S | 1404 | 3.0% |
| Other values (50) | 18795 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 47074 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 9196 | ||
| e | 4557 | 9.7% |
| a | 2878 | 6.1% |
| x | 1977 | 4.2% |
| 1 | 1928 | 4.1% |
| p | 1668 | 3.5% |
| l | 1565 | 3.3% |
| i | 1555 | 3.3% |
| r | 1551 | 3.3% |
| S | 1404 | 3.0% |
| Other values (50) | 18795 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 47074 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 9196 | ||
| e | 4557 | 9.7% |
| a | 2878 | 6.1% |
| x | 1977 | 4.2% |
| 1 | 1928 | 4.1% |
| p | 1668 | 3.5% |
| l | 1565 | 3.3% |
| i | 1555 | 3.3% |
| r | 1551 | 3.3% |
| S | 1404 | 3.0% |
| Other values (50) | 18795 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 47074 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 9196 | ||
| e | 4557 | 9.7% |
| a | 2878 | 6.1% |
| x | 1977 | 4.2% |
| 1 | 1928 | 4.1% |
| p | 1668 | 3.5% |
| l | 1565 | 3.3% |
| i | 1555 | 3.3% |
| r | 1551 | 3.3% |
| S | 1404 | 3.0% |
| Other values (50) | 18795 |
Item Price
Real number (ℝ)
High correlation  Zeros 
| Distinct | 80 |
|---|---|
| Distinct (%) | 5.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.210807 |
| Minimum | 0 |
|---|---|
| Maximum | 450 |
| Zeros | 15 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.99 |
| Q1 | 5.64 |
| median | 9.34 |
| Q3 | 23.99 |
| 95-th percentile | 48.99 |
| Maximum | 450 |
| Range | 450 |
| Interquartile range (IQR) | 18.35 |
Descriptive statistics
| Standard deviation | 23.497427 |
|---|---|
| Coefficient of variation (CV) | 1.3652717 |
| Kurtosis | 109.28361 |
| Mean | 17.210807 |
| Median Absolute Deviation (MAD) | 7.12 |
| Skewness | 8.003066 |
| Sum | 24112.34 |
| Variance | 552.12909 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 34.93 | 129 | 9.2% |
| 8.49 | 127 | 9.1% |
| 3.99 | 81 | 5.8% |
| 0.99 | 65 | 4.6% |
| 27.49 | 64 | 4.6% |
| 23.99 | 52 | 3.7% |
| 7.25 | 47 | 3.4% |
| 48.99 | 45 | 3.2% |
| 6.99 | 43 | 3.1% |
| 9.34 | 42 | 3.0% |
| Other values (70) | 706 |
| Value | Count | Frequency (%) |
| 0 | 15 | 1.1% |
| 0.5 | 5 | 0.4% |
| 0.85 | 6 | 0.4% |
| 0.95 | 17 | 1.2% |
| 0.99 | 65 | |
| 1.45 | 14 | 1.0% |
| 1.5 | 1 | 0.1% |
| 1.99 | 36 | |
| 2.49 | 4 | 0.3% |
| 2.64 | 3 | 0.2% |
| Value | Count | Frequency (%) |
| 450 | 1 | 0.1% |
| 259.61 | 1 | 0.1% |
| 257 | 2 | 0.1% |
| 162 | 3 | 0.2% |
| 127 | 2 | 0.1% |
| 117 | 8 | |
| 100 | 1 | 0.1% |
| 67.99 | 1 | 0.1% |
| 60 | 1 | 0.1% |
| 57.99 | 3 | 0.2% |
Item Options Total Price
Real number (ℝ)
High correlation  Zeros 
| Distinct | 234 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.80242 |
| Minimum | 0 |
|---|---|
| Maximum | 450 |
| Zeros | 15 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.99 |
| Q1 | 6.26 |
| median | 10.94 |
| Q3 | 23.99 |
| 95-th percentile | 48.99 |
| Maximum | 450 |
| Range | 450 |
| Interquartile range (IQR) | 17.73 |
Descriptive statistics
| Standard deviation | 23.593913 |
|---|---|
| Coefficient of variation (CV) | 1.3253206 |
| Kurtosis | 107.17806 |
| Mean | 17.80242 |
| Median Absolute Deviation (MAD) | 6.95 |
| Skewness | 7.9013024 |
| Sum | 24941.19 |
| Variance | 556.67273 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8.49 | 96 | 6.9% |
| 3.99 | 81 | 5.8% |
| 0.99 | 65 | 4.6% |
| 34.93 | 64 | 4.6% |
| 27.49 | 46 | 3.3% |
| 48.99 | 45 | 3.2% |
| 9.34 | 40 | 2.9% |
| 1.99 | 36 | 2.6% |
| 23.99 | 33 | 2.4% |
| 4.99 | 32 | 2.3% |
| Other values (224) | 863 |
| Value | Count | Frequency (%) |
| 0 | 15 | 1.1% |
| 0.5 | 5 | 0.4% |
| 0.85 | 6 | 0.4% |
| 0.95 | 17 | 1.2% |
| 0.99 | 65 | |
| 1.45 | 14 | 1.0% |
| 1.5 | 1 | 0.1% |
| 1.99 | 36 | |
| 2.49 | 4 | 0.3% |
| 2.64 | 3 | 0.2% |
| Value | Count | Frequency (%) |
| 450 | 1 | 0.1% |
| 260 | 1 | 0.1% |
| 259.61 | 1 | 0.1% |
| 257 | 1 | 0.1% |
| 162 | 3 | |
| 127 | 2 | 0.1% |
| 120 | 3 | |
| 117 | 5 | |
| 100 | 1 | 0.1% |
| 67.99 | 1 | 0.1% |
Item Total Price
Real number (ℝ)
High correlation  Zeros 
| Distinct | 599 |
|---|---|
| Distinct (%) | 42.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21.940514 |
| Minimum | 0 |
|---|---|
| Maximum | 567.98 |
| Zeros | 15 |
| Zeros (%) | 1.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1.08 |
| Q1 | 7.38 |
| median | 13.08 |
| Q3 | 27.35 |
| 95-th percentile | 53.65 |
| Maximum | 567.98 |
| Range | 567.98 |
| Interquartile range (IQR) | 19.97 |
Descriptive statistics
| Standard deviation | 33.87017 |
|---|---|
| Coefficient of variation (CV) | 1.5437273 |
| Kurtosis | 101.38988 |
| Mean | 21.940514 |
| Median Absolute Deviation (MAD) | 8.71 |
| Skewness | 8.2777867 |
| Sum | 30738.66 |
| Variance | 1147.1884 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.37 | 48 | 3.4% |
| 1.08 | 36 | 2.6% |
| 9.3 | 35 | 2.5% |
| 10.23 | 33 | 2.4% |
| 38.25 | 31 | 2.2% |
| 26.27 | 20 | 1.4% |
| 7.94 | 18 | 1.3% |
| 19.11 | 17 | 1.2% |
| 25.68 | 16 | 1.1% |
| 53.64 | 16 | 1.1% |
| Other values (589) | 1131 |
| Value | Count | Frequency (%) |
| 0 | 15 | |
| 0.54 | 2 | 0.1% |
| 0.55 | 3 | 0.2% |
| 0.91 | 2 | 0.1% |
| 0.93 | 2 | 0.1% |
| 0.97 | 1 | 0.1% |
| 0.99 | 2 | 0.1% |
| 1.02 | 3 | 0.2% |
| 1.03 | 3 | 0.2% |
| 1.04 | 7 |
| Value | Count | Frequency (%) |
| 567.98 | 1 | |
| 492.75 | 1 | |
| 438 | 1 | |
| 284.7 | 1 | |
| 283.8 | 1 | |
| 281.41 | 1 | |
| 267.74 | 1 | |
| 229.49 | 1 | |
| 177.39 | 2 | |
| 176.92 | 1 |
Interactions
Correlations
| Channels | Fulfillment Type | Item Options Total Price | Item Price | Item Quantity | Item Total Price | Item Variation | Order Subtotal | Order Tax Total | Order Total | Recipient Address | Recipient Address 2 | Recipient City | Recipient Country | Recipient Postal Code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Channels | 1.000 | 0.651 | 0.501 | 0.501 | 0.157 | 0.526 | 0.149 | 0.429 | 0.429 | 0.434 | 1.000 | 1.000 | 1.000 | 0.999 | 1.000 |
| Fulfillment Type | 0.651 | 1.000 | 0.112 | 0.112 | 0.156 | 0.227 | 0.118 | 0.473 | 0.473 | 0.475 | 0.680 | 0.930 | 0.825 | 0.997 | 0.586 |
| Item Options Total Price | 0.501 | 0.112 | 1.000 | 0.987 | -0.140 | 0.963 | 0.065 | 0.064 | 0.073 | 0.068 | 0.449 | 0.710 | 0.113 | 0.139 | 0.007 |
| Item Price | 0.501 | 0.112 | 0.987 | 1.000 | -0.132 | 0.953 | 0.065 | 0.068 | 0.077 | 0.072 | 0.449 | 0.710 | 0.113 | 0.139 | 0.026 |
| Item Quantity | 0.157 | 0.156 | -0.140 | -0.132 | 1.000 | 0.071 | 0.000 | 0.230 | 0.229 | 0.230 | 1.000 | 1.000 | 1.000 | 0.244 | 0.018 |
| Item Total Price | 0.526 | 0.227 | 0.963 | 0.953 | 0.071 | 1.000 | 0.000 | 0.119 | 0.131 | 0.123 | 0.440 | 0.930 | 0.131 | 0.370 | 0.012 |
| Item Variation | 0.149 | 0.118 | 0.065 | 0.065 | 0.000 | 0.000 | 1.000 | 0.036 | 0.036 | 0.046 | 0.000 | 0.000 | 0.124 | 0.212 | 0.206 |
| Order Subtotal | 0.429 | 0.473 | 0.064 | 0.068 | 0.230 | 0.119 | 0.036 | 1.000 | 0.989 | 0.996 | 0.721 | 1.000 | 0.160 | 0.828 | -0.036 |
| Order Tax Total | 0.429 | 0.473 | 0.073 | 0.077 | 0.229 | 0.131 | 0.036 | 0.989 | 1.000 | 0.989 | 0.721 | 1.000 | 0.160 | 0.828 | -0.036 |
| Order Total | 0.434 | 0.475 | 0.068 | 0.072 | 0.230 | 0.123 | 0.046 | 0.996 | 0.989 | 1.000 | 0.588 | 1.000 | 0.170 | 0.827 | -0.046 |
| Recipient Address | 1.000 | 0.680 | 0.449 | 0.449 | 1.000 | 0.440 | 0.000 | 0.721 | 0.721 | 0.588 | 1.000 | 1.000 | 0.800 | 1.000 | 0.983 |
| Recipient Address 2 | 1.000 | 0.930 | 0.710 | 0.710 | 1.000 | 0.930 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.930 |
| Recipient City | 1.000 | 0.825 | 0.113 | 0.113 | 1.000 | 0.131 | 0.124 | 0.160 | 0.160 | 0.170 | 0.800 | 1.000 | 1.000 | 1.000 | 0.683 |
| Recipient Country | 0.999 | 0.997 | 0.139 | 0.139 | 0.244 | 0.370 | 0.212 | 0.828 | 0.828 | 0.827 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| Recipient Postal Code | 1.000 | 0.586 | 0.007 | 0.026 | 0.018 | 0.012 | 0.206 | -0.036 | -0.036 | -0.046 | 0.983 | 0.930 | 0.683 | 1.000 | 1.000 |
Missing values
Sample
| Order | Order Date | Currency | Order Subtotal | Order Shipping Price | Order Tax Total | Order Total | Order Refunded Amount | Fulfillment Date | Fulfillment Type | Fulfillment Status | Channels | Fulfillment Location | Fulfillment Notes | Recipient Name | Recipient Email | Recipient Phone | Recipient Address | Recipient Address 2 | Recipient Postal Code | Recipient City | Recipient Region | Recipient Country | Item Quantity | Item Name | Item SKU | Item Variation | Item Modifiers | Item Price | Item Options Total Price | Item Total Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Uber Eats Delivery 8F819 | 2024/12/18 | USD | 37.90 | NaN | 3.46 | 41.36 | NaN | 12/18/2024, 1:58 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 8F819-Diana O. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | CRISPY CHICKEN SANDWICH | NaN | Regular | NaN | 16.46 | 16.46 | 18.02 |
| 1 | Uber Eats Delivery 8F819 | 2024/12/18 | USD | 37.90 | NaN | 3.46 | 41.36 | NaN | 12/18/2024, 1:58 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 8F819-Diana O. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | LOADED FRIES | NaN | Regular | 1 x Signature BBQ Sauce Drizzle, 1 x Salt and Pepper | 11.99 | 12.74 | 13.95 |
| 2 | Uber Eats Delivery 8F819 | 2024/12/18 | USD | 37.90 | NaN | 3.46 | 41.36 | NaN | 12/18/2024, 1:58 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 8F819-Diana O. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | CREAMY BLUE CHEESE DIP | NaN | Regular | NaN | 1.45 | 1.45 | 1.45 |
| 3 | Uber Eats Delivery 8F819 | 2024/12/18 | USD | 37.90 | NaN | 3.46 | 41.36 | NaN | 12/18/2024, 1:58 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 8F819-Diana O. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | ARTISAN MAC AND CHEESE | NaN | Side | NaN | 7.25 | 7.25 | 7.94 |
| 4 | Uber Eats Delivery 7751A | 2024/12/17 | USD | 113.09 | NaN | 10.74 | 123.83 | NaN | 12/17/2024, 7:56 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 7751A-Lilit A. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 3 | BEEF SHORT RIB | NaN | Regular | NaN | 33.95 | 33.95 | 111.52 |
| 5 | Uber Eats Delivery 7751A | 2024/12/17 | USD | 113.09 | NaN | 10.74 | 123.83 | NaN | 12/17/2024, 7:56 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 7751A-Lilit A. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | ARTISAN MAC AND CHEESE | NaN | Side | NaN | 7.25 | 7.25 | 7.94 |
| 6 | Uber Eats Delivery 7751A | 2024/12/17 | USD | 113.09 | NaN | 10.74 | 123.83 | NaN | 12/17/2024, 7:56 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 7751A-Lilit A. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | GRILLED SWEET CORN | NaN | Regular | NaN | 3.99 | 3.99 | 4.37 |
| 7 | Postmates Delivery 3BDB7 | 2024/12/17 | USD | 26.32 | NaN | 2.50 | 28.82 | NaN | 12/17/2024, 7:41 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 3BDB7-Arman D. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 2 | BELLY BITES | NaN | 4 Bites | NaN | 8.49 | 8.49 | 18.59 |
| 8 | Postmates Delivery 3BDB7 | 2024/12/17 | USD | 26.32 | NaN | 2.50 | 28.82 | NaN | 12/17/2024, 7:41 PM | Pickup | Completed | Postmates Delivery | Belly Rubb | NaN | 3BDB7-Arman D. | NaN | +1 312-766-6835 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | CRINKLE FRIES | NaN | Full | 1 x Lemon Pepper | 9.34 | 9.34 | 10.23 |
| 9 | DOORDASH | 2024/12/17 | USD | 34.19 | NaN | 3.25 | 37.44 | NaN | 12/17/2024, 7:27 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | Peter K | point-of-sale-integration@doordash.com | 8552228111 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | PEAR GORGONZOLA SALAD | NaN | Regular | NaN | 8.49 | 8.49 | 9.30 |
| Order | Order Date | Currency | Order Subtotal | Order Shipping Price | Order Tax Total | Order Total | Order Refunded Amount | Fulfillment Date | Fulfillment Type | Fulfillment Status | Channels | Fulfillment Location | Fulfillment Notes | Recipient Name | Recipient Email | Recipient Phone | Recipient Address | Recipient Address 2 | Recipient Postal Code | Recipient City | Recipient Region | Recipient Country | Item Quantity | Item Name | Item SKU | Item Variation | Item Modifiers | Item Price | Item Options Total Price | Item Total Price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1391 | DOORDASH | 2024/01/05 | USD | 20.81 | NaN | 1.98 | 22.79 | NaN | 01/05/2024, 1:49 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | Timothy L | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | BELLY SLIDERS | NaN | 2 sliders | 1 x Signature BBQ Sauce | 9.98 | 10.83 | 11.86 |
| 1392 | DOORDASH | 2024/01/04 | USD | 35.37 | NaN | 2.60 | 37.97 | NaN | 01/04/2024, 5:31 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | Benjamin B | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | GRILLED SWEET CORN | NaN | Regular | NaN | 2.99 | 2.99 | 3.21 |
| 1393 | DOORDASH | 2024/01/04 | USD | 35.37 | NaN | 2.60 | 37.97 | NaN | 01/04/2024, 5:31 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | Benjamin B | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | CRINKLE FRIES | NaN | Side, Rosemary pepper | 1 x Sweet and Spicy BBQ Sauce, 1 x Signature BBQ Sauce | 4.99 | 6.69 | 7.18 |
| 1394 | DOORDASH | 2024/01/04 | USD | 35.37 | NaN | 2.60 | 37.97 | NaN | 01/04/2024, 5:31 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | Benjamin B | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | GET YOUR BABY BACK! | NaN | Half rack | 1 x Sweet and Spicy BBQ Sauce, 1 x Signature BBQ Sauce | 23.99 | 25.69 | 27.58 |
| 1395 | DOORDASH | 2024/01/03 | USD | 24.84 | NaN | 2.36 | 27.20 | NaN | 01/03/2024, 2:29 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | Alan S | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | GET YOUR BABY BACK! | NaN | Half rack | 1 x Signature BBQ Sauce | 23.99 | 24.84 | 27.20 |
| 1396 | Square Online 824358568 | 2023/12/30 | USD | 36.17 | NaN | 3.44 | 45.04 | NaN | 12/30/2023, 4:15 PM | Pickup | Completed | BELLY RUBB | BBQ Catering | Barbecue To Go and Delivery | Belly Rubb | NaN | Narek Ekmekjyan | narek.ek@gmail.com | +13106632447 | 13346 Saticoy St | unit 1 | 91605.0 | Los Angeles | CA | US | 1 | GET YOUR BABY BACK! | NaN | Half rack | 1 x Pickled peppers, 1 x Signature BBQ Sauce, 1 x Sweet and Spicy BBQ Sauce | 23.99 | 26.19 | 28.68 |
| 1397 | Square Online 824358568 | 2023/12/30 | USD | 36.17 | NaN | 3.44 | 45.04 | NaN | 12/30/2023, 4:15 PM | Pickup | Completed | BELLY RUBB | BBQ Catering | Barbecue To Go and Delivery | Belly Rubb | NaN | Narek Ekmekjyan | narek.ek@gmail.com | +13106632447 | 13346 Saticoy St | unit 1 | 91605.0 | Los Angeles | CA | US | 1 | BELLY SLIDERS | NaN | 2 sliders | NaN | 9.98 | 9.98 | 10.93 |
| 1398 | DOORDASH | 2023/12/30 | USD | 53.40 | NaN | 4.31 | 57.71 | NaN | 12/30/2023, 3:50 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | PickUp-Narek E | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | BELLY SLIDERS | NaN | 4 sliders | 1 x Sweet and Spicy BBQ Sauce, 1 x Signature BBQ Sauce | 14.57 | 16.27 | 17.58 |
| 1399 | DOORDASH | 2023/12/30 | USD | 53.40 | NaN | 4.31 | 57.71 | NaN | 12/30/2023, 3:50 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | PickUp-Narek E | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | GET YOUR BABY BACK! | NaN | Full Rack | 1 x Sweet and Spicy BBQ Sauce, 1 x Signature BBQ Sauce, 1 x Pickled peppers | 34.93 | 37.13 | 40.13 |
| 1400 | DOORDASH | 2023/12/28 | USD | 9.34 | NaN | 0.89 | 10.23 | NaN | 12/28/2023, 1:30 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | Test T | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | CRINKLE FRIES | NaN | Full, Truffle salt | 1 x Blue Cheese | 8.49 | 9.34 | 10.23 |
Duplicate rows
Most frequently occurring
| Order | Order Date | Currency | Order Subtotal | Order Tax Total | Order Total | Fulfillment Date | Fulfillment Type | Fulfillment Status | Channels | Fulfillment Location | Fulfillment Notes | Recipient Name | Recipient Email | Recipient Phone | Recipient Address | Recipient Address 2 | Recipient Postal Code | Recipient City | Recipient Region | Recipient Country | Item Quantity | Item Name | Item Variation | Item Modifiers | Item Price | Item Options Total Price | Item Total Price | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | DOORDASH | 2024/05/18 | USD | 76.05 | 6.75 | 82.8 | 05/18/2024, 9:04 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | David C | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | BAKED BABY POTATOES | Regular | NaN | 6.29 | 6.29 | 6.85 | 2 |
| 1 | DOORDASH | 2024/05/18 | USD | 76.05 | 6.75 | 82.8 | 05/18/2024, 9:04 PM | Pickup | Completed | DoorDash | Belly Rubb | NaN | David C | point-of-sale-integration@doordash.com | 8559731040 | NaN | NaN | NaN | NaN | NaN | NaN | 1 | Beef Short Rib | Regular | NaN | 27.49 | 27.49 | 29.93 | 2 |